Digital Redlining EDA - Consolidated
ProKofa Solutions, LLP
2025-05-24
Map Debug Tools
Data Loading and Preparation
##
## === DIAGNOSTIC: Building Details All Students Data ===## Number of rows: 105## Column names: Building IRN, Building Name, District_IRN, District Name, County, Region, Student Group, Enrollment, Enrollment Percent, Attendance Rate, Mobility Rate, Chronic Absenteeism Rate## Sample Building IRNs: 000224, 000489, 000575, 000729, 000736## === After renaming columns ===## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <chr> <chr> <chr>
## 1 000224 Adlai Stevenson Sc… 100.0 87.6 20.0
## 2 000489 Almira 100.0 86.1 8.5
## 3 000575 Northwest School o… 100.0 84.2 27.5
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <chr>##
## === After numeric conversion ===## # A tibble: 3 × 6
## SchoolIRN SchoolName Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 000224 Adlai Stevenson Sc… 1 0.876 0.2
## 2 000489 Almira 1 0.861 0.085
## 3 000575 Northwest School o… 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>## Using geocoded school data##
## === DIAGNOSTIC: Cleveland Schools Data (before merge) ===## Number of rows: 105## Column names: SchoolIRN ..., SchoolName ..., DistrictIRN ..., DistrictName ..., Latitude ..., Longitude ..., SyntheticCoords ..., geo_lat ..., geo_lng ..., geo_address ..., Address ...## Sample SchoolIRNs: 000224, 000489, 000575, 000729, 000736##
## === DIAGNOSTIC: SchoolIRN Comparison ===## First 5 SchoolIRNs in Cleveland Schools Data: 000224, 000489, 000575, 000729, 000736## First 5 SchoolIRNs in Building Details Data: 000224, 000489, 000575, 000729, 000736## Number of matching SchoolIRNs: 105 out of 105 schools##
## === DIAGNOSTIC: Cleveland Schools Data (after merge) ===## Number of rows: 105## Sample of joined data:## # A tibble: 3 × 6
## SchoolName SchoolIRN Enrollment_Percent Attendance_Rate Mobility_Rate
## <chr> <chr> <dbl> <dbl> <dbl>
## 1 Adlai Stevenson Sc… 000224 1 0.876 0.2
## 2 Almira 000489 1 0.861 0.085
## 3 Northwest School o… 000575 1 0.842 0.275
## # ℹ 1 more variable: Chronic_Absenteeism_Rate <dbl>##
## Cleveland Buildings 22-23: 973 rows## Cleveland Buildings 23-24: 936 rows## Cleveland Buildings 23-24 (All Students): 105 rows## Cleveland Student Opportunity 22-23: 1090 rows## Cleveland Student Opportunity 23-24: 1050 rows## Cleveland Schools Data: 105 rows## Schools with values for Attendance Rate: 105## Schools with values for Chronic Absenteeism Rate: 105## Schools with values for Mobility Rate: 105## Schools with values for Enrollment Percent: 1051. Redlining Map (HOLC Grades + Schools)
## [1] "Schools data summary:"
## [1] "Number of schools: 105"
## [1] "School columns: SchoolIRN, SchoolName, DistrictIRN, DistrictName, Latitude, Longitude, SyntheticCoords, geo_lat, geo_lng, geo_address"
## [1] "Sample coordinates: -81.5509837, -81.7518031, -81.7671731 41.4548682, 41.4616156, 41.482455"## Map dimensions: x2. Building Details Report - 2023-2024
The map below allows you to select different performance indicators to visualize across schools in Cleveland. Each indicator is color-coded to show variation in performance, with HOLC redlining districts displayed as background polygons.
Select Performance Indicator:
## [1] "Available columns in cleveland_schools_data:"## [1] "SchoolIRN" "SchoolName"
## [3] "DistrictIRN" "DistrictName"
## [5] "Latitude" "Longitude"
## [7] "SyntheticCoords" "geo_lat"
## [9] "geo_lng" "geo_address"
## [11] "Address" "Enrollment_Percent"
## [13] "Attendance_Rate" "Mobility_Rate"
## [15] "Chronic_Absenteeism_Rate"
About the Enhanced Performance Map: This interactive
map now uses real performance data from the Building Details Report
23-24 for the “All Students” subgroup. The map displays Cleveland
schools colored by their performance on three key indicators:
- Attendance Rate: Percentage of students with regular attendance (higher is better)
- Mobility Rate: Percentage of students who moved during the year (lower is better)
- Chronic Absenteeism Rate: Percentage of students missing 10% or more school days (lower is better)
Schools are displayed on top of the historical redlining districts from the 1930s HOLC. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators - the school dots will change colors accordingly, and a dynamic legend shows the color scale for each indicator.
3. Building Student Opportunity Report - 2023-2024
The maps below visualize data from the Building Student Opportunity Report for Cleveland schools. Each indicator shows opportunities and resources available to students, with HOLC redlining districts displayed as background polygons.
Select Student Opportunity Indicator:
## Loaded Student Opportunity data for 105 schools## Available indicators:## - All-Day Kindergarten Enrollment : 105 schools with data
## - Physical Education/Wellness Course Enrollment : 105 schools with data
## - World Language Course Enrollment : 105 schools with data
## - Career Technical Education Enrollment (Grades 7-12) : 105 schools with data
## - Cocurricular Activities Participation : 105 schools with data
## - Advanced Courses Participation (AP, IB, Honors, CCP) : 105 schools with data
## - Gifted Services : 105 schools with data
## - Enrichment/Support Programs Outside School Day : 105 schools with data
## - School Breakfast Program Participation : 105 schools with data
## - Students Transported by School Bus : 105 schools with data
## - Portable Technology Devices Ratio : 105 schools with data
About the Student Opportunity Maps: These interactive
maps use data from the Building Student Opportunity Report 2023-24 for
the “All Students” subgroup. The maps display Cleveland schools colored
by student access to various educational opportunities and resources:
- All-Day Kindergarten Enrollment: Percentage of kindergarten students enrolled in all-day programs
- Physical Education/Wellness: Percentage of students enrolled in PE or wellness courses
- World Language: Percentage of students enrolled in world language courses
- Career Technical Education: Percentage of students in grades 7-12 enrolled in CTE courses
- Cocurricular Activities: Percentage of students participating in one or more cocurricular activities
- Advanced Courses: Percentage of students participating in AP, IB, Honors, or CCP courses
- Gifted Services: Percentage of students identified and receiving gifted services
- Enrichment/Support Programs: Percentage of students in programs outside normal school hours
- School Breakfast Program: Percentage of eligible students participating in breakfast programs
- School Bus Transportation: Number of students transported by school bus each day
- Technology Devices: Ratio of portable technology devices that students may take home
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. The system automatically handles “NC” (not counted) values by treating them as missing data. Use the dropdown above the map to switch between indicators.
4. Correlation Table
5. College, Career, Workforce, and Military Readiness Report 2023-2024 | Overview
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) Overview report for Cleveland schools. Each indicator shows school performance on college and career readiness metrics, with HOLC redlining districts displayed as background polygons.
Select College and Career Readiness Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Overview:"## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "Number of Students in the 4-year Graduation Cohort who Completed a Pathway and are Prepared for College or Career Success"
## [8] "Graduation Cohort"
## [9] "Percent of Students in the 4-Year Graduation Cohort who Completed a Pathway and are Prepared for College or Career Success"
## [10] "Percent of Students Remediation Free on ACT or SAT"
## [11] "Honors Diploma Percent"
## [12] "Percent of Students who earned 3 or more 3+ AP or 4+ IB Tests"
## [13] "Percent of Students who Earned at Least 12 Credential Points in a Single Career Field or a State Recognized License"
## [14] "Percent of Students who Earned 12 or more Dual Enrollment Credits"
## [15] "Percent of Students Enlisted in Military"
## [16] "Percent of Students Accepted into an Apprenticeship Program Post High School"
## [17] "Percent of Students Completing a Pre-Apprenticeship"
## [18] "Percent of Students Completing an Apprenticeship"
## [19] "Percent of Students Achieving Proficiency on 3 or More Technical Assessments"
## [20] "Percent of Students Earning the Ohio Means Jobs Readiness Seal and 250+ Hours of Work-Based Learning"
## [21] "Watermark"##
## Summary of data for each indicator (before modifications):## pathway_success: 31 schools with data, 74 schools with NC values (70%)
## remediation_free: 31 schools with data, 74 schools with NC values (70%)
## honors_diploma: 31 schools with data, 74 schools with NC values (70%)
## ap_ib_success: 31 schools with data, 74 schools with NC values (70%)
## credential_points: 31 schools with data, 74 schools with NC values (70%)
## dual_enrollment: 31 schools with data, 74 schools with NC values (70%)
## military: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship_accepted: 31 schools with data, 74 schools with NC values (70%)
## pre_apprenticeship: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship_complete: 31 schools with data, 74 schools with NC values (70%)
## technical_assessments: 31 schools with data, 74 schools with NC values (70%)
## omj_readiness: 31 schools with data, 74 schools with NC values (70%)## Prepared CCWMR Overview data for 105 schools## Indicator: pathway_success - Found 74 schools with NC/NA values
## Indicator: pathway_success - Using range: 0 % to 100 %## Indicator: remediation_free - Found 74 schools with NC/NA values
## Indicator: remediation_free - Using range: 0 % to 40 %## Indicator: honors_diploma - Found 74 schools with NC/NA values
## Indicator: honors_diploma - Using range: 0 % to 30 %## Indicator: ap_ib_success - Found 74 schools with NC/NA values
## Indicator: ap_ib_success - Using range: 0 % to 30 %## Indicator: credential_points - Found 74 schools with NC/NA values
## Indicator: credential_points - Using range: 0 % to 70 %## Indicator: dual_enrollment - Found 74 schools with NC/NA values
## Indicator: dual_enrollment - Using range: 0 % to 100 %## Indicator: military - Found 74 schools with NC/NA values
## Indicator: military - Using range: 0 % to 20 %## Indicator: apprenticeship_accepted - Found 74 schools with NC/NA values
## Indicator: apprenticeship_accepted - Using range: 0 % to 20 %## Indicator: pre_apprenticeship - Found 74 schools with NC/NA values
## Indicator: pre_apprenticeship - Using range: 0 % to 30 %## Indicator: apprenticeship_complete - Found 74 schools with NC/NA values
## Indicator: apprenticeship_complete - Using range: 0 % to 20 %## Indicator: technical_assessments - Found 74 schools with NC/NA values
## Indicator: technical_assessments - Using range: 0 % to 30 %## Indicator: omj_readiness - Found 74 schools with NC/NA values
## Indicator: omj_readiness - Using range: 0 % to 20 %
About the College and Career Readiness Overview Maps:
These interactive maps use data from the CCWMR Overview report 2023-24
for Cleveland schools. The maps display schools colored by various
college and career readiness indicators:
- Completed Pathway & Prepared for Success: Percentage of students in the 4-year graduation cohort who completed a pathway and are prepared for college or career success
- Remediation Free on ACT or SAT: Percentage of students scoring high enough to be considered remediation-free
- Honors Diploma: Percentage of students earning an Honors Diploma
- AP/IB Test Success: Percentage of students earning 3+ on AP or 4+ on IB tests
- Career Field Credential Points: Percentage of students earning at least 12 credential points in a single career field or a state-recognized license
- Dual Enrollment Credits: Percentage of students earning 12 or more dual enrollment credits
- Military Enlistment: Percentage of students enlisted in military service
- Apprenticeship Indicators: Multiple metrics on apprenticeship acceptance and completion
- Technical Assessment Proficiency: Percentage of students achieving proficiency on 3 or more technical assessments
- Ohio Means Jobs Readiness Seal: Percentage of students earning the OMJ Readiness Seal and 250+ hours of work-based learning
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset.
6. College, Career, Workforce, and Military Readiness Report 2023-2024 | Additional Details
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) report for Cleveland schools. Each indicator shows student participation and achievement in college readiness metrics, with HOLC redlining districts displayed as background polygons.
Select College and Career Readiness Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Additional_Details:"## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "ACT Participation Percent"
## [8] "Percent of Students Remediation Free on ACT"
## [9] "SAT Participation Percent"
## [10] "Percent of Students Remediation Free on SAT"
## [11] "AP Participation Percent"
## [12] "IB Participation Percent"
## [13] "Percent of Students Earning 3+ on AP Test"
## [14] "Percent of Students Earning 4+ on IB Test"
## [15] "Watermark"## No 'Student Group' column found, using all 105 rows##
## Summary of ACT Participation data before modifications:## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.00000 0.00000 0.01400 0.04513 0.02700 0.72700 74## Number of schools with NA (NC) values: 74## Column act_participation has 74 missing values
## Preserving 74 NC values for act_participation
## Column act_remediation has 74 missing values
## Preserving 74 NC values for act_remediation
## Column sat_participation has 74 missing values
## Preserving 74 NC values for sat_participation
## Column sat_remediation has 74 missing values
## Preserving 74 NC values for sat_remediation
## Column ap_participation has 74 missing values
## Preserving 74 NC values for ap_participation
## Column ib_participation has 74 missing values
## Preserving 74 NC values for ib_participation
## Column ap_success has 74 missing values
## Preserving 74 NC values for ap_success
## Column ib_success has 74 missing values
## Preserving 74 NC values for ib_success##
## Summary of ACT Participation data after modifications:## Min. 1st Qu. Median Mean 3rd Qu. Max. NA's
## 0.00000 0.00000 0.01400 0.04513 0.02700 0.72700 74## Number of schools with NA (NC) values: 74## Prepared CCWMR data for 105 schools## Indicator: act_participation - Found 74 schools with NC/NA values
## Excluded 1 specific schools from act_participation map
## Value distribution for act_participation :
##
## 0 0.9 1 1.1 1.3 1.4 1.5 1.6 2 2.1 2.6 2.8 3.1 4.4 5.4 13.2
## 9 1 1 1 2 2 1 2 2 1 1 2 1 1 1 1
## 13.7
## 1
## Schools with ~1.4% ACT Participation:
## name
## 1 Glenville High School
## 2 Lincoln West School Of Global Studies
## 3 Rhodes School of Environmental Studies
## 4 Garrett Morgan School of Engineering & Innovation
## 5 Cleveland School Of The Arts High School
## Indicator: act_participation - Using range: 0 % to 30 %## Indicator: act_remediation - Found 74 schools with NC/NA values
## Value distribution for act_remediation :
##
## 0 1.1 2.9
## 29 1 1
## Indicator: act_remediation - Using range: 0 % to 20 %## Indicator: sat_participation - Found 74 schools with NC/NA values
## Value distribution for sat_participation :
##
## 0 20 33.3 41.3 46.2 52 53.8 55.1 55.5 56 60.4 60.9 61.5 62.5 65.3 66.7
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## 67.1 69.5 69.7 70.8 72.1 74.8 80.4 81.5 87.7 89.1 90.1 91.8 92.4 93.7 97.1
## 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1
## Indicator: sat_participation - Using range: 0 % to 100 %## Indicator: sat_remediation - Found 74 schools with NC/NA values
## Value distribution for sat_remediation :
##
## 0 1.3 1.4 1.5 1.8 2.1 2.3 2.6 2.8 3.1 4.1 4.9 5.3 5.8 7 7.4
## 10 1 1 2 1 1 1 1 1 1 1 1 2 1 1 1
## 9.4 16.5 24.2 26.5
## 1 1 1 1
## Indicator: sat_remediation - Using range: 0 % to 40 %## Indicator: ap_participation - Found 74 schools with NC/NA values
## Value distribution for ap_participation :
##
## 0 1.3 1.5 1.8 2 4.5 4.6 5.6 6.4 16.7 17.4 20 20.2 20.4 20.8 21.4
## 7 1 1 2 1 1 1 2 1 1 1 1 1 1 1 2
## 27.4 28 30.8 84.4 96.8 97.1
## 1 1 1 1 1 1
## Indicator: ap_participation - Using range: 0 % to 100 %## Indicator: ib_participation - Found 74 schools with NC/NA values
## Value distribution for ib_participation :
##
## 0
## 31
## Indicator: ib_participation - Using range: 0 % to 20 %## Indicator: ap_success - Found 74 schools with NC/NA values
## Value distribution for ap_success :
##
## 0 1.3 1.4 1.6 2.9 4.3 6.2 6.3 7.1 7.5 10.9 21.1 22.1
## 18 1 1 1 1 1 1 2 1 1 1 1 1
## Indicator: ap_success - Using range: 0 % to 30 %## Indicator: ib_success - Found 74 schools with NC/NA values
## Value distribution for ib_success :
##
## 0
## 31
## Indicator: ib_success - Using range: 0 % to 20 %
About the College, Career, Workforce, and Military Readiness
Maps: These interactive maps use data from the CCWMR report
2023-24 for Cleveland schools. The maps display schools colored by
student participation and achievement in college readiness metrics:
- ACT Participation: Percentage of students who took the ACT test
- ACT Remediation Free: Percentage of students who scored high enough to be considered remediation-free
- SAT Participation: Percentage of students who took the SAT test
- SAT Remediation Free: Percentage of students who scored high enough to be considered remediation-free
- AP Participation: Percentage of students taking Advanced Placement courses
- IB Participation: Percentage of students taking International Baccalaureate courses
- AP Success (Score 3+): Percentage of AP test-takers who scored 3 or higher
- IB Success (Score 4+): Percentage of IB test-takers who scored 4 or higher
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset. For the ACT Participation map, Northeast Ohio College Preparatory School (72.7% participation) is excluded as it is a College Prep oriented school with disproportionately higher participation than other schools.
6. College, Career, Workforce, and Military Readiness Report 2023-2024 | Follow-Up Collection
This section visualizes data from the College, Career, Workforce, and Military Readiness (CCWMR) Follow-Up Collection report for Cleveland schools. Each indicator shows post-graduation outcomes for students, with HOLC redlining districts displayed as background polygons.
Select Post-Graduation Outcome Indicator:
## [1] "Columns in Cleveland_CCWMR_23_24_Follow_Up_Collection:"## [1] "Building IRN"
## [2] "Building Name"
## [3] "District_IRN"
## [4] "District Name"
## [5] "County"
## [6] "Region"
## [7] "Denominator (2023 Graduates)"
## [8] "Number of Students Enrolled in Post-Secondary Education"
## [9] "Percent of Students Enrolled in Post-Secondary Education"
## [10] "Number of Students Enrolled in 2-Year Post-Secondary Institution"
## [11] "Percent of Students Enrolled in 2-Year Post-Secondary Institution"
## [12] "Number of Students Enrolled in 4-Year Post-Secondary Institution"
## [13] "Percent of Students Enrolled in 4-Year Post-Secondary Institution"
## [14] "Number of Students Enrolled in Ohio Technical School"
## [15] "Percent of Students Enrolled in Ohio Technical School"
## [16] "Number of Students Enrolled in Other Post-Secondary Institution"
## [17] "Percent of Students Enrolled in Other Post-Secondary Institution"
## [18] "Number of Students Entered into Apprenticeship or Other Job Training"
## [19] "Percent of Students Entered into Apprenticeship or Other Job Training"
## [20] "Number of Students Gainfully Employed"
## [21] "Percent of Students Gainfully Employed"
## [22] "Number of Students Enlisted in Military"
## [23] "Percent of Students Enlisted in Military"
## [24] "Watermark"##
## Summary of data for each indicator (before modifications):## postsecondary: 31 schools with data, 74 schools with NC values (70%)
## twoyear: 31 schools with data, 74 schools with NC values (70%)
## fouryear: 31 schools with data, 74 schools with NC values (70%)
## technical: 31 schools with data, 74 schools with NC values (70%)
## other: 31 schools with data, 74 schools with NC values (70%)
## apprenticeship: 31 schools with data, 74 schools with NC values (70%)
## employed: 31 schools with data, 74 schools with NC values (70%)
## military: 31 schools with data, 74 schools with NC values (70%)## Prepared CCWMR Follow-Up data for 105 schools## Indicator: postsecondary - Found 74 schools with NC/NA values
## Indicator: postsecondary - Using range: 0 % to 80 %## Indicator: twoyear - Found 74 schools with NC/NA values
## Indicator: twoyear - Using range: 0 % to 40 %## Indicator: fouryear - Found 74 schools with NC/NA values
## Indicator: fouryear - Using range: 0 % to 70 %## Indicator: technical - Found 74 schools with NC/NA values
## Indicator: technical - Using range: 0 % to 20 %## Indicator: other - Found 74 schools with NC/NA values
## Indicator: other - Using range: 0 % to 20 %## Indicator: apprenticeship - Found 74 schools with NC/NA values
## Indicator: apprenticeship - Using range: 0 % to 20 %## Indicator: employed - Found 74 schools with NC/NA values
## Indicator: employed - Using range: 0 % to 60 %## Indicator: military - Found 74 schools with NC/NA values
## Indicator: military - Using range: 0 % to 20 %
About the Post-Graduation Outcomes Maps: These
interactive maps use data from the CCWMR Follow-Up Collection report
2023-24 for Cleveland schools. The maps display schools colored by
post-graduation outcomes for students:
- Post-Secondary Education: Percentage of graduates enrolled in any post-secondary education
- 2-Year Institution: Percentage of graduates enrolled in 2-year colleges
- 4-Year Institution: Percentage of graduates enrolled in 4-year colleges/universities
- Ohio Technical School: Percentage of graduates enrolled in Ohio technical schools
- Other Post-Secondary: Percentage of graduates in other post-secondary institutions
- Apprenticeship/Training: Percentage of graduates in apprenticeships or job training
- Gainful Employment: Percentage of graduates who are gainfully employed
- Military Enlistment: Percentage of graduates who enlisted in military service
Schools are displayed on top of the historical redlining districts from the 1930s HOLC grades. Schools with white circles indicate “Not Counted (NC)” values in the dataset. The data represents outcomes for 2023 graduates as reported in the 2023-24 school year collection.